include("../dbinfo_inc.php");
$id=$_GET['id'];
$urlsource=$_GET['url'];
$table_groups=$table_groups;
function find_name($id_person) {
include("../dbinfo_inc.php");
mysql_connect($mysqlhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query_person="SELECT * FROM $table_people WHERE id_person='$id_person'";
$result_person=mysql_query($query_person);
mysql_close ();
if ($result_person) { $num_person=mysql_numrows($result_person);} else { $num_person=0;}
$i_person=0;
while ($i_person < $num_person) {
$name_first=mysql_result($result_person,$i_person,"name_first");
$name_last=mysql_result($result_person,$i_person,"name_last");
$name_preferred=mysql_result($result_person,$i_person,"name_preferred");
++$i_person;
}
if ($name_preferred) {$name_to_use = $name_preferred;} else {$name_to_use = $name_first;}
return $name_to_use. " " . $name_last;
}
mysql_connect($mysqlhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
if ($num_group_ud=0) {
echo "no records selected
";
} else {
if ($new_ud == "new") {
$num_group_ud="1";
} else {
$query_group_ud="SELECT * FROM $table_groups WHERE id_group=$id_group";
$result_group_ud=mysql_query($query_group_ud);
$num_group_ud=mysql_numrows($result_group_ud);
}
}
$i_group_ud=0;
while ($i_group_ud < $num_group_ud) {
if ($new_ud == "ud") {
$id_group=mysql_result($result_group_ud,$_group_udi,"id_group");
$type_group=mysql_result($result_group_ud,$i_group_ud,"type_group");
$name_group=mysql_result($result_group_ud,$i_group_ud,"name_group");
$location_group=mysql_result($result_group_ud,$i_group_ud,"location_group");
$id_leader_person=mysql_result($result_group_ud,$i_group_ud,"id_leader_person");
$id_admin_person=mysql_result($result_group_ud,$i_group_ud,"id_admin_person");
$comment=mysql_result($result_group_ud,$i_group_ud,"comment");
}
mysql_close();
?>